SELECT T.* ,
  (SELECT SD.NAME
  FROM FD_DICTIONARY_TY SD
  WHERE SD.ID = T.PARENT_ID
  ) AS PARENT_NA
FROM FD_DICTIONARY_TY T
WHERE T.ID = :ID